Tabela LServiceEquipment

Definicja tabeli LServiceEquipment

Name

LServiceEquipment

Code

LServiceEquipment

Comment

 


Lista kolumn tabeli LServiceEquipment

Name

Code

ServID

ServID

EquipmentID

EquipmentID

UnitID

UnitID

ConsumptionValue

ConsumptionValue


Kolumna ServID tabeli LServiceEquipment

Definicja kolumny ServID tabeli LServiceEquipment

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EquipmentID tabeli LServiceEquipment

Definicja kolumny EquipmentID tabeli LServiceEquipment

Name

EquipmentID

Code

EquipmentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli LServiceEquipment

Definicja kolumny UnitID tabeli LServiceEquipment

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ConsumptionValue tabeli LServiceEquipment

Definicja kolumny ConsumptionValue tabeli LServiceEquipment

Name

ConsumptionValue

Code

ConsumptionValue

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Lista kluczy tabeli LServiceEquipment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServiceEquipment

Definicja klucza Identifier_1 tabeli LServiceEquipment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment